Model Table PURCHASE PART

This model dimension represents condition codes and is based on the IFS Cloud dimension DIM_PURCHASE_PART. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Def Buying Unit of MeasureDefault Buying Unit of Measure Code
Purchase PartBuilt as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION
Purchase Part CodeRepresents the CODE of the dimension, i.e. the puchase part code.
Purchase Part Code DescriptionBuilt as CODE + ' - ' + DESCRIPTION
Purchase Part DescriptionRepresents the DESCRIPTION of a purchase part.
Purchase Part Description - NumberBuilt as DESCRIPTION + ' - ' +( CODE)
SiteThe Site ID to which the purchase part is delivered

Hierarchies

Hierarchy Level
PurchPartHy
Site
Purchase Part

USED BY MODEL(S)

Model Name
Procurement

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
PURCHASE PARTDIM_PURCHASE_PART_BIDIM_PURCHASE_PART_BIDIM_PURCHASE_PARTOn Line